How to: Freeze titles both vertically and horizontally.

Solution:


Select the cell just below and to the right of the titles. Select 'Freeze Panes' from the 'Window' menu.

NOTE: To unfreeze the titles, select the 'Window' menu and select 'Unfreeze Panes'.